/*
               File: ModVeh
        Description: Graba Nuevo Vehiculo
             Author: GeneXus Java Generator version 8_0_9-040
       Generated on: 28 de Setiembre de 2010 14:38:23.71
       Program type: Callable routine
          Main DBMS: sqlserver
*/
import java.sql.*;
import com.genexus.db.*;
import com.genexus.*;
import com.genexus.distributed.*;

public final class pmodveh extends GXProcedure
{
   public pmodveh( int remoteHandle )
   {
      super( remoteHandle , new ModelContext( pmodveh.class ), "" );
   }

   public pmodveh( int remoteHandle ,
                   ModelContext context )
   {
      super( remoteHandle , context, "" );
   }

   public void execute( String aP0 ,
                        GxObjectCollection aP1 ,
                        short aP2 ,
                        byte[] aP3 )
   {
      execute_int(aP0, aP1, aP2, aP3);
   }

   private void execute_int( String aP0 ,
                             GxObjectCollection aP1 ,
                             short aP2 ,
                             byte[] aP3 )
   {
      pmodveh.this.AV10Usucod = aP0;
      pmodveh.this.AV8Colecci = aP1;
      pmodveh.this.AV11Mvehco = aP2;
      pmodveh.this.aP3 = aP3;
      initialize();
      /* GeneXus formulas */
      /* Output device settings */
      AV15GXFIC0 = (short)(1) ;
      while ( ( AV15GXFIC0 <= AV8Colecci.getItemCount() ) )
      {
         AV9Item = ((SdtSDTVehiculo_SDTVehiculoItem)AV8Colecci.item(AV15GXFIC0)) ;
         AV16GXLvl1 = 0 ;
         /* Using cursor P00142 */
         pr_default.execute(0, new Object[] {new Short(AV11Mvehco)});
         while ( (pr_default.getStatus(0) != 101) )
         {
            A519MVehCo = P00142_A519MVehCo[0] ;
            A520MVehNr = P00142_A520MVehNr[0] ;
            A521MVehNo = P00142_A521MVehNo[0] ;
            A376TipAut = P00142_A376TipAut[0] ;
            A385ModCod = P00142_A385ModCod[0] ;
            A189MarCod = P00142_A189MarCod[0] ;
            A522MVehAn = P00142_A522MVehAn[0] ;
            A523CmbCod = P00142_A523CmbCod[0] ;
            A525MVehCo = P00142_A525MVehCo[0] ;
            A526MVehNr = P00142_A526MVehNr[0] ;
            A527MVehNr = P00142_A527MVehNr[0] ;
            A528MVehNr = P00142_A528MVehNr[0] ;
            A529MVehPe = P00142_A529MVehPe[0] ;
            A530MVehPe = P00142_A530MVehPe[0] ;
            A531MVehCa = P00142_A531MVehCa[0] ;
            A532MVehLo = P00142_A532MVehLo[0] ;
            A533MVehAl = P00142_A533MVehAl[0] ;
            A534MVehAn = P00142_A534MVehAn[0] ;
            A535MVehNr = P00142_A535MVehNr[0] ;
            A536MVehNr = P00142_A536MVehNr[0] ;
            A537MVehNr = P00142_A537MVehNr[0] ;
            A538MVehNr = P00142_A538MVehNr[0] ;
            A539CmbCod = P00142_A539CmbCod[0] ;
            A540MVehCa = P00142_A540MVehCa[0] ;
            A541MVehCa = P00142_A541MVehCa[0] ;
            A542MVehCo = P00142_A542MVehCo[0] ;
            A543MVehNM = P00142_A543MVehNM[0] ;
            A544MVehNs = P00142_A544MVehNs[0] ;
            A545MVehNC = P00142_A545MVehNC[0] ;
            A546MVehPS = P00142_A546MVehPS[0] ;
            A547MVehCU = P00142_A547MVehCU[0] ;
            A548MVehLo = P00142_A548MVehLo[0] ;
            A549MVehAl = P00142_A549MVehAl[0] ;
            A550MVehNe = P00142_A550MVehNe[0] ;
            A551MVehNR = P00142_A551MVehNR[0] ;
            A552MVehNA = P00142_A552MVehNA[0] ;
            A553MVehNP = P00142_A553MVehNP[0] ;
            A593MVehCo = P00142_A593MVehCo[0] ;
            A594MVehPB = P00142_A594MVehPB[0] ;
            A595MVehAn = P00142_A595MVehAn[0] ;
            A589MVehFU = P00142_A589MVehFU[0] ;
            A590MVehHU = P00142_A590MVehHU[0] ;
            A591MVehUU = P00142_A591MVehUU[0] ;
            AV16GXLvl1 = (byte)(1) ;
            A520MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnropla() ;
            A521MVehNo = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnompro() ;
            A376TipAut = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Tipautcod() ;
            A385ModCod = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Modcod() ;
            A189MarCod = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Marcod() ;
            A522MVehAn = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehanofab() ;
            A523CmbCod = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Cmbcod() ;
            A525MVehCo = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcol() ;
            A526MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnromot() ;
            A527MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnroser() ;
            A528MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnrocil() ;
            A529MVehPe = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehpessec() ;
            A530MVehPe = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehpesbru() ;
            A531MVehCa = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcaruti() ;
            A532MVehLo = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehlon() ;
            A533MVehAl = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehalt() ;
            A534MVehAn = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehanc() ;
            A535MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnroeje() ;
            A536MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnrorue() ;
            A537MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnroasi() ;
            A538MVehNr = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnropue() ;
            A539CmbCod = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Cmbcodcnv() ;
            A540MVehCa = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcar() ;
            A541MVehCa = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcarcnv() ;
            A542MVehCo = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcolcnv() ;
            A543MVehNM = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnmocnv() ;
            A544MVehNs = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnsecnv() ;
            A545MVehNC = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehncicnv() ;
            A546MVehPS = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehpsecnv() ;
            A547MVehCU = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcutlcnv() ;
            A548MVehLo = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehloncnv() ;
            A549MVehAl = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehaltcnv() ;
            A550MVehNe = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnejcnv() ;
            A551MVehNR = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnrucnv() ;
            A552MVehNA = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnascnv() ;
            A553MVehNP = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehnpucnv() ;
            A593MVehCo = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehcodcnv() ;
            A594MVehPB = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehpbrcnv() ;
            A595MVehAn = AV9Item.getgxTv_SdtSDTVehiculo_SDTVehiculoItem_Mvehanccnv() ;
            A589MVehFU = GXutil.serverDate( context, remoteHandle, "DEFAULT") ;
            A590MVehHU = GXutil.serverTime( context, remoteHandle, "DEFAULT") ;
            A591MVehUU = AV10Usucod ;
            /* Using cursor P00143 */
            pr_default.execute(1, new Object[] {A520MVehNr, A521MVehNo, new Byte(A376TipAut), A385ModCod, A189MarCod, new Short(A522MVehAn), new Integer(A523CmbCod), A525MVehCo, A526MVehNr, A527MVehNr, new Integer(A528MVehNr), new Integer(A529MVehPe), new Integer(A530MVehPe), new Integer(A531MVehCa), new Integer(A532MVehLo), new Integer(A533MVehAl), new Integer(A534MVehAn), new Integer(A535MVehNr), new Integer(A536MVehNr), new Integer(A537MVehNr), new Integer(A538MVehNr), new Integer(A539CmbCod), A540MVehCa, A541MVehCa, A542MVehCo, A543MVehNM, A544MVehNs, new Integer(A545MVehNC), new Integer(A546MVehPS), new Integer(A547MVehCU), new Integer(A548MVehLo), new Integer(A549MVehAl), new Integer(A550MVehNe), new Integer(A551MVehNR), new Integer(A552MVehNA), new Integer(A553MVehNP), new Long(A593MVehCo), new Integer(A594MVehPB), new Integer(A595MVehAn), A589MVehFU, A590MVehHU, A591MVehUU, new Short(A519MVehCo)});
            /* Check if program is canceled. */
            /* Exiting from a For First loop. */
            if (true) break;
         }
         pr_default.close(0);
         if ( ( AV16GXLvl1 == 0 ) )
         {
            AV12Pout = (byte)(1) ;
         }
         AV15GXFIC0 = (short)(AV15GXFIC0+1) ;
      }
      cleanup();
   }

   protected void cleanup( )
   {
      this.aP3[0] = pmodveh.this.AV12Pout;
      Application.commit(context, remoteHandle, "DEFAULT", "pmodveh");
      exitApplication();
   }

   /* Aggregate/select formulas */
   public void initialize( )
   {
      AV12Pout = 0 ;
      AV15GXFIC0 = 0 ;
      AV9Item = new SdtSDTVehiculo_SDTVehiculoItem(context);
      AV16GXLvl1 = 0 ;
      P00142_A519MVehCo = new short[1] ;
      P00142_A520MVehNr = new String[] {""} ;
      P00142_A521MVehNo = new String[] {""} ;
      P00142_A376TipAut = new byte[1] ;
      P00142_A385ModCod = new String[] {""} ;
      P00142_A189MarCod = new String[] {""} ;
      P00142_A522MVehAn = new short[1] ;
      P00142_A523CmbCod = new int[1] ;
      P00142_A525MVehCo = new String[] {""} ;
      P00142_A526MVehNr = new String[] {""} ;
      P00142_A527MVehNr = new String[] {""} ;
      P00142_A528MVehNr = new int[1] ;
      P00142_A529MVehPe = new int[1] ;
      P00142_A530MVehPe = new int[1] ;
      P00142_A531MVehCa = new int[1] ;
      P00142_A532MVehLo = new int[1] ;
      P00142_A533MVehAl = new int[1] ;
      P00142_A534MVehAn = new int[1] ;
      P00142_A535MVehNr = new int[1] ;
      P00142_A536MVehNr = new int[1] ;
      P00142_A537MVehNr = new int[1] ;
      P00142_A538MVehNr = new int[1] ;
      P00142_A539CmbCod = new int[1] ;
      P00142_A540MVehCa = new String[] {""} ;
      P00142_A541MVehCa = new String[] {""} ;
      P00142_A542MVehCo = new String[] {""} ;
      P00142_A543MVehNM = new String[] {""} ;
      P00142_A544MVehNs = new String[] {""} ;
      P00142_A545MVehNC = new int[1] ;
      P00142_A546MVehPS = new int[1] ;
      P00142_A547MVehCU = new int[1] ;
      P00142_A548MVehLo = new int[1] ;
      P00142_A549MVehAl = new int[1] ;
      P00142_A550MVehNe = new int[1] ;
      P00142_A551MVehNR = new int[1] ;
      P00142_A552MVehNA = new int[1] ;
      P00142_A553MVehNP = new int[1] ;
      P00142_A593MVehCo = new long[1] ;
      P00142_A594MVehPB = new int[1] ;
      P00142_A595MVehAn = new int[1] ;
      P00142_A589MVehFU = new java.util.Date[] {GXutil.nullDate()} ;
      P00142_A590MVehHU = new String[] {""} ;
      P00142_A591MVehUU = new String[] {""} ;
      A519MVehCo = 0 ;
      A520MVehNr = "" ;
      A521MVehNo = "" ;
      A376TipAut = 0 ;
      A385ModCod = "" ;
      A189MarCod = "" ;
      A522MVehAn = 0 ;
      A523CmbCod = 0 ;
      A525MVehCo = "" ;
      A526MVehNr = "" ;
      A527MVehNr = "" ;
      A528MVehNr = 0 ;
      A529MVehPe = 0 ;
      A530MVehPe = 0 ;
      A531MVehCa = 0 ;
      A532MVehLo = 0 ;
      A533MVehAl = 0 ;
      A534MVehAn = 0 ;
      A535MVehNr = 0 ;
      A536MVehNr = 0 ;
      A537MVehNr = 0 ;
      A538MVehNr = 0 ;
      A539CmbCod = 0 ;
      A540MVehCa = "" ;
      A541MVehCa = "" ;
      A542MVehCo = "" ;
      A543MVehNM = "" ;
      A544MVehNs = "" ;
      A545MVehNC = 0 ;
      A546MVehPS = 0 ;
      A547MVehCU = 0 ;
      A548MVehLo = 0 ;
      A549MVehAl = 0 ;
      A550MVehNe = 0 ;
      A551MVehNR = 0 ;
      A552MVehNA = 0 ;
      A553MVehNP = 0 ;
      A593MVehCo = 0 ;
      A594MVehPB = 0 ;
      A595MVehAn = 0 ;
      A589MVehFU = GXutil.nullDate() ;
      A590MVehHU = "" ;
      A591MVehUU = "" ;
      pr_default = new DataStoreProvider(context, remoteHandle, new pmodveh__default(),
         new Object[] {
             new Object[] {
            P00142_A519MVehCo, P00142_A520MVehNr, P00142_A521MVehNo, P00142_A376TipAut, P00142_A385ModCod, P00142_A189MarCod, P00142_A522MVehAn, P00142_A523CmbCod, P00142_A525MVehCo, P00142_A526MVehNr,
            P00142_A527MVehNr, P00142_A528MVehNr, P00142_A529MVehPe, P00142_A530MVehPe, P00142_A531MVehCa, P00142_A532MVehLo, P00142_A533MVehAl, P00142_A534MVehAn, P00142_A535MVehNr, P00142_A536MVehNr,
            P00142_A537MVehNr, P00142_A538MVehNr, P00142_A539CmbCod, P00142_A540MVehCa, P00142_A541MVehCa, P00142_A542MVehCo, P00142_A543MVehNM, P00142_A544MVehNs, P00142_A545MVehNC, P00142_A546MVehPS,
            P00142_A547MVehCU, P00142_A548MVehLo, P00142_A549MVehAl, P00142_A550MVehNe, P00142_A551MVehNR, P00142_A552MVehNA, P00142_A553MVehNP, P00142_A593MVehCo, P00142_A594MVehPB, P00142_A595MVehAn,
            P00142_A589MVehFU, P00142_A590MVehHU, P00142_A591MVehUU
            }
            , new Object[] {
            }
         }
      );
      /* GeneXus formulas. */
      Gx_err = 0 ;
   }

   private byte AV12Pout ;
   private byte AV16GXLvl1 ;
   private byte A376TipAut ;
   private short AV11Mvehco ;
   private short AV15GXFIC0 ;
   private short A519MVehCo ;
   private short A522MVehAn ;
   private short Gx_err ;
   private int A523CmbCod ;
   private int A528MVehNr ;
   private int A529MVehPe ;
   private int A530MVehPe ;
   private int A531MVehCa ;
   private int A532MVehLo ;
   private int A533MVehAl ;
   private int A534MVehAn ;
   private int A535MVehNr ;
   private int A536MVehNr ;
   private int A537MVehNr ;
   private int A538MVehNr ;
   private int A539CmbCod ;
   private int A545MVehNC ;
   private int A546MVehPS ;
   private int A547MVehCU ;
   private int A548MVehLo ;
   private int A549MVehAl ;
   private int A550MVehNe ;
   private int A551MVehNR ;
   private int A552MVehNA ;
   private int A553MVehNP ;
   private int A594MVehPB ;
   private int A595MVehAn ;
   private long A593MVehCo ;
   private String AV10Usucod ;
   private String A520MVehNr ;
   private String A521MVehNo ;
   private String A385ModCod ;
   private String A189MarCod ;
   private String A525MVehCo ;
   private String A526MVehNr ;
   private String A527MVehNr ;
   private String A540MVehCa ;
   private String A541MVehCa ;
   private String A542MVehCo ;
   private String A543MVehNM ;
   private String A544MVehNs ;
   private String A590MVehHU ;
   private String A591MVehUU ;
   private java.util.Date A589MVehFU ;
   private byte[] aP3 ;
   private IDataStoreProvider pr_default ;
   private short[] P00142_A519MVehCo ;
   private String[] P00142_A520MVehNr ;
   private String[] P00142_A521MVehNo ;
   private byte[] P00142_A376TipAut ;
   private String[] P00142_A385ModCod ;
   private String[] P00142_A189MarCod ;
   private short[] P00142_A522MVehAn ;
   private int[] P00142_A523CmbCod ;
   private String[] P00142_A525MVehCo ;
   private String[] P00142_A526MVehNr ;
   private String[] P00142_A527MVehNr ;
   private int[] P00142_A528MVehNr ;
   private int[] P00142_A529MVehPe ;
   private int[] P00142_A530MVehPe ;
   private int[] P00142_A531MVehCa ;
   private int[] P00142_A532MVehLo ;
   private int[] P00142_A533MVehAl ;
   private int[] P00142_A534MVehAn ;
   private int[] P00142_A535MVehNr ;
   private int[] P00142_A536MVehNr ;
   private int[] P00142_A537MVehNr ;
   private int[] P00142_A538MVehNr ;
   private int[] P00142_A539CmbCod ;
   private String[] P00142_A540MVehCa ;
   private String[] P00142_A541MVehCa ;
   private String[] P00142_A542MVehCo ;
   private String[] P00142_A543MVehNM ;
   private String[] P00142_A544MVehNs ;
   private int[] P00142_A545MVehNC ;
   private int[] P00142_A546MVehPS ;
   private int[] P00142_A547MVehCU ;
   private int[] P00142_A548MVehLo ;
   private int[] P00142_A549MVehAl ;
   private int[] P00142_A550MVehNe ;
   private int[] P00142_A551MVehNR ;
   private int[] P00142_A552MVehNA ;
   private int[] P00142_A553MVehNP ;
   private long[] P00142_A593MVehCo ;
   private int[] P00142_A594MVehPB ;
   private int[] P00142_A595MVehAn ;
   private java.util.Date[] P00142_A589MVehFU ;
   private String[] P00142_A590MVehHU ;
   private String[] P00142_A591MVehUU ;
   private GxObjectCollection AV8Colecci ;
   private SdtSDTVehiculo_SDTVehiculoItem AV9Item ;
}

final class pmodveh__default extends DataStoreHelperBase implements ILocalDataStoreHelper
{
   public Cursor[] getCursors( )
   {
      return new Cursor[] {
          new ForEachCursor("P00142", "SELECT [MVehCod], [MVehNroPla], [MVehNomPro], [TipAutCod], [ModCod], [MarCod], [MVehAnoFab], [CmbCod], [MVehCol], [MVehNroMot], [MVehNroSer], [MVehNroCil], [MVehPesSec], [MVehPesBru], [MVehCarUti], [MVehLon], [MVehAlt], [MVehAnc], [MVehNroEje], [MVehNroRue], [MVehNroAsi], [MVehNroPue], [CmbCodCnv], [MVehCar], [MVehCarCnv], [MVehColCnv], [MVehNMoCnv], [MVehNseCnv], [MVehNCiCnv], [MVehPSeCnv], [MVehCUtlCn], [MVehLonCnv], [MVehAltCnv], [MVehNejCnv], [MVehNRuCnv], [MVehNAsCnv], [MVehNPuCnv], [MVehCodCnv], [MVehPBrCnv], [MVehAncCnv], [MVehFUM], [MVehHUM], [MVehUUM] FROM [MMVEH10] WITH (UPDLOCK) WHERE [MVehCod] = ? ",true, GX_NOMASK + GX_MASKLOOPLOCK, false, this,0,true )
         ,new UpdateCursor("P00143", "UPDATE [MMVEH10] SET [MVehNroPla]=?, [MVehNomPro]=?, [TipAutCod]=?, [ModCod]=?, [MarCod]=?, [MVehAnoFab]=?, [CmbCod]=?, [MVehCol]=?, [MVehNroMot]=?, [MVehNroSer]=?, [MVehNroCil]=?, [MVehPesSec]=?, [MVehPesBru]=?, [MVehCarUti]=?, [MVehLon]=?, [MVehAlt]=?, [MVehAnc]=?, [MVehNroEje]=?, [MVehNroRue]=?, [MVehNroAsi]=?, [MVehNroPue]=?, [CmbCodCnv]=?, [MVehCar]=?, [MVehCarCnv]=?, [MVehColCnv]=?, [MVehNMoCnv]=?, [MVehNseCnv]=?, [MVehNCiCnv]=?, [MVehPSeCnv]=?, [MVehCUtlCn]=?, [MVehLonCnv]=?, [MVehAltCnv]=?, [MVehNejCnv]=?, [MVehNRuCnv]=?, [MVehNAsCnv]=?, [MVehNPuCnv]=?, [MVehCodCnv]=?, [MVehPBrCnv]=?, [MVehAncCnv]=?, [MVehFUM]=?, [MVehHUM]=?, [MVehUUM]=?  WHERE [MVehCod] = ?", GX_NOMASK + GX_MASKLOOPLOCK)
      };
   }

   public void getResults( int cursor ,
                           IFieldGetter rslt ,
                           Object[] buf ) throws SQLException
   {
      switch ( cursor )
      {
            case 0 :
               ((short[]) buf[0])[0] = rslt.getShort(1) ;
               ((String[]) buf[1])[0] = rslt.getString(2, 20) ;
               ((String[]) buf[2])[0] = rslt.getString(3, 50) ;
               ((byte[]) buf[3])[0] = rslt.getByte(4) ;
               ((String[]) buf[4])[0] = rslt.getString(5, 10) ;
               ((String[]) buf[5])[0] = rslt.getString(6, 10) ;
               ((short[]) buf[6])[0] = rslt.getShort(7) ;
               ((int[]) buf[7])[0] = rslt.getInt(8) ;
               ((String[]) buf[8])[0] = rslt.getString(9, 50) ;
               ((String[]) buf[9])[0] = rslt.getString(10, 50) ;
               ((String[]) buf[10])[0] = rslt.getString(11, 50) ;
               ((int[]) buf[11])[0] = rslt.getInt(12) ;
               ((int[]) buf[12])[0] = rslt.getInt(13) ;
               ((int[]) buf[13])[0] = rslt.getInt(14) ;
               ((int[]) buf[14])[0] = rslt.getInt(15) ;
               ((int[]) buf[15])[0] = rslt.getInt(16) ;
               ((int[]) buf[16])[0] = rslt.getInt(17) ;
               ((int[]) buf[17])[0] = rslt.getInt(18) ;
               ((int[]) buf[18])[0] = rslt.getInt(19) ;
               ((int[]) buf[19])[0] = rslt.getInt(20) ;
               ((int[]) buf[20])[0] = rslt.getInt(21) ;
               ((int[]) buf[21])[0] = rslt.getInt(22) ;
               ((int[]) buf[22])[0] = rslt.getInt(23) ;
               ((String[]) buf[23])[0] = rslt.getString(24, 50) ;
               ((String[]) buf[24])[0] = rslt.getString(25, 50) ;
               ((String[]) buf[25])[0] = rslt.getString(26, 50) ;
               ((String[]) buf[26])[0] = rslt.getString(27, 50) ;
               ((String[]) buf[27])[0] = rslt.getString(28, 50) ;
               ((int[]) buf[28])[0] = rslt.getInt(29) ;
               ((int[]) buf[29])[0] = rslt.getInt(30) ;
               ((int[]) buf[30])[0] = rslt.getInt(31) ;
               ((int[]) buf[31])[0] = rslt.getInt(32) ;
               ((int[]) buf[32])[0] = rslt.getInt(33) ;
               ((int[]) buf[33])[0] = rslt.getInt(34) ;
               ((int[]) buf[34])[0] = rslt.getInt(35) ;
               ((int[]) buf[35])[0] = rslt.getInt(36) ;
               ((int[]) buf[36])[0] = rslt.getInt(37) ;
               ((long[]) buf[37])[0] = rslt.getLong(38) ;
               ((int[]) buf[38])[0] = rslt.getInt(39) ;
               ((int[]) buf[39])[0] = rslt.getInt(40) ;
               ((java.util.Date[]) buf[40])[0] = rslt.getGXDate(41) ;
               ((String[]) buf[41])[0] = rslt.getString(42, 8) ;
               ((String[]) buf[42])[0] = rslt.getString(43, 10) ;
               break;
      }
   }

   public void setParameters( int cursor ,
                              IFieldSetter stmt ,
                              Object[] parms ) throws SQLException
   {
      switch ( cursor )
      {
            case 0 :
               stmt.setShort(1, ((Short) parms[0]).shortValue());
               break;
            case 1 :
               stmt.setString(1, (String)parms[0], 20);
               stmt.setString(2, (String)parms[1], 50);
               stmt.setByte(3, ((Byte) parms[2]).byteValue());
               stmt.setString(4, (String)parms[3], 10);
               stmt.setString(5, (String)parms[4], 10);
               stmt.setShort(6, ((Short) parms[5]).shortValue());
               stmt.setInt(7, ((Integer) parms[6]).intValue());
               stmt.setString(8, (String)parms[7], 50);
               stmt.setString(9, (String)parms[8], 50);
               stmt.setString(10, (String)parms[9], 50);
               stmt.setInt(11, ((Integer) parms[10]).intValue());
               stmt.setInt(12, ((Integer) parms[11]).intValue());
               stmt.setInt(13, ((Integer) parms[12]).intValue());
               stmt.setInt(14, ((Integer) parms[13]).intValue());
               stmt.setInt(15, ((Integer) parms[14]).intValue());
               stmt.setInt(16, ((Integer) parms[15]).intValue());
               stmt.setInt(17, ((Integer) parms[16]).intValue());
               stmt.setInt(18, ((Integer) parms[17]).intValue());
               stmt.setInt(19, ((Integer) parms[18]).intValue());
               stmt.setInt(20, ((Integer) parms[19]).intValue());
               stmt.setInt(21, ((Integer) parms[20]).intValue());
               stmt.setInt(22, ((Integer) parms[21]).intValue());
               stmt.setString(23, (String)parms[22], 50);
               stmt.setString(24, (String)parms[23], 50);
               stmt.setString(25, (String)parms[24], 50);
               stmt.setString(26, (String)parms[25], 50);
               stmt.setString(27, (String)parms[26], 50);
               stmt.setInt(28, ((Integer) parms[27]).intValue());
               stmt.setInt(29, ((Integer) parms[28]).intValue());
               stmt.setInt(30, ((Integer) parms[29]).intValue());
               stmt.setInt(31, ((Integer) parms[30]).intValue());
               stmt.setInt(32, ((Integer) parms[31]).intValue());
               stmt.setInt(33, ((Integer) parms[32]).intValue());
               stmt.setInt(34, ((Integer) parms[33]).intValue());
               stmt.setInt(35, ((Integer) parms[34]).intValue());
               stmt.setInt(36, ((Integer) parms[35]).intValue());
               stmt.setLong(37, ((Long) parms[36]).longValue());
               stmt.setInt(38, ((Integer) parms[37]).intValue());
               stmt.setInt(39, ((Integer) parms[38]).intValue());
               stmt.setDate(40, (java.util.Date)parms[39]);
               stmt.setString(41, (String)parms[40], 8);
               stmt.setString(42, (String)parms[41], 10);
               stmt.setShort(43, ((Short) parms[42]).shortValue());
               break;
      }
   }

}

